Release 10.1A: OpenEdge Getting Started:
New and Revised Features

Proc-Text-Buffer technique

The first technique, proc-text-buffer, requires you to access result sets available through a pseudo table for which each row is a long character string. Consequently, you must parse each long string to access specific fields. And, although you can use the proc-text-buffer technique to hold the results from all of the SQL statements included in a stored procedure, the buffer you create to hold the results can only hold one results set record from one result set at a time.

Review the example presented in Figure 2–2.

RUN STORED-PROC send-sql-statement      (“SELECT name, address, city, state, postal_code FROM customer WHERE      credit_limit>=500”). FOR EACH proc-text-buffer:      DISPLAY proc-text-buffer. END.

Figure 2–2: Proc-text-buffer technique example

Since proc-text-buffer contains the character equivalent of the columns described by the SELECT statement, Figure 2–2 simply shows the character string results that display when the results are returned from the executed procedure; the individual columns of the result set have not been parsed.